package com.nbjtjc.safe.mapper.edu;

import java.util.List;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.nbjtjc.safe.bean.Page;
import com.nbjtjc.safe.model.edu.EduPlanList;
import com.nbjtjc.util.MyMapper;
@Mapper
public interface EduPlanListMapper extends MyMapper<EduPlanList> {
	List<EduPlanList> search(@Param("epl") EduPlanList eduPlanList);
	
	List<EduPlanList> searchDetail(@Param("epl") EduPlanList eduPlanList);


//	@Select("select * from edu_plan_item where plan_id = #{planId}")
//	EduPlanList selectByPlanId(@Param("planId") int planId);
	
//	@Select("select * from edu_daily_examine_list where record_id = #{recordId}")
//	List<EduPlanList>  findByRecordId(@Param("recordId") int recordId);
    @Select("SELECT DISTINCT DATE_FORMAT(create_year,'%Y') AS 'year' FROM edu_plan_list WHERE company_id = #{companyId} and create_year IS NOT NULL")
    List<String> findYear(@Param("companyId")Integer companyId);

	List<EduPlanList> searchSubcompany(@Param("compId") int compId);
    


//	List<EduPlanList> searchHis(@Param("epl") EduPlanList eduPlanListSample);
}